SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This delightful residence is nestled in the picturesque village of Plainfield, NH. A truly inviting property that offers a harmonious blend of classic charm and modern comfort. As you approach the home, you'll be greeted by its timeless design and beautifully maintained lawn and gardens. The open-concept kitchen to dining to living room is perfect for both daily living and entertaining others. The well-appointed kitchen is a chef's dream, complete with newer fridge, a dishwasher, and microwave, generous granite counter space, and plenty of cabinetry for storage. Many other features including: Central AC, mudroom, second floor laundry, updated fixtures, newly painted throughout, and professional interior designer crafted rooms. Located just a short drive from local amenities and scenic attractions, this home combines the best of both worlds—peaceful village living with convenient access to everyday necessities. Only 15 miles (25mins) to DHMC! Don’t miss your chance to own this exceptional property. Agent related to sellers.
Description:Charming 1800s cape in a great West Lebanon neighborhood! Large eat-in kitchen with pellet stove, large mudroom with full bathroom, living room with gorgeous hardwood floors and cozy attached den with window seats and built-ins. First floor primary bedroom with attached bathroom and laundry room. Two large bedrooms upstairs and walk-in attic ready for future living space or storage. Two newly renovated spacious and sunny front porches, perfect for enjoying the spring fresh air. Upgrades include - newer roof, mini splits, new exterior paint and doors, and refinished wood floors. Lovely level yard for gardening and play, private back deck and one car detached garage. SO much charm - don't miss this one! Showings begin at open house - Saturday 4/26 10-12 and Sunday 4/27 12-2.
Description:Stunning New Hampshire Lakefront! Beautiful water views, mountain views, bald eagle sightings and the haunting call of the loons are just a few of the things you will experience from this rustic camp perched on 94 feet of waterfront on the eastern bank of Mascoma Lake. Camp out in the existing cottage and enjoy the raised detached deck area, sandy beach bottom and private dock. What could be more delightful than summers boating with friends and family, fishing and swimming from your private dock or just watching the passing sailboats. This magical location can be used just as it is or it could be the site of your new Lakefront Dream House! Much of the preliminary leg work has been completed with survey and perking information available. This is a must see property just in time for summer fun! Open House Sat 4/12 9-11 and Sun 4/13 11-1
Description:Move-in ready and fully remodeled, this 3-bedroom, 2-bathroom Raised Ranch offers modern comfort with thoughtful upgrades. Recent improvements include a new asphalt roof (2024), mini-splits (2023), and custom kitchen with quartz countertops, ample cabinetry, and a spacious island. Additional upgrades include luxury vinyl plank flooring, a new PEX plumbing, a new hot water heater, relined chimney, and refurbished pellet stoves. The main level has three bedrooms and an updated full bathroom, while the lower level offers three flexible rooms—ideal for an office, playroom, or gym—plus a newly updated bathroom. OPEN HOUSE Tuesday April 1 4-6pm.
Description:So, you're probably wondering about the whole "location, location, location" thing in real estate, right? Well, this place totally nails it! Just a hop, skip, and a 15-minute drive away from Dartmouth University and Dartmouth Hitchcock Hospital, this sweet home is calling out for someone to make it their own. It's like it's sitting there waiting for you to throw some elbow grease and love into it, and boom, you've got yourself a real gem. Now, imagine a house with an open layout that's begging for a little bit of your creative flair. Picture big ol' bedrooms that could fit a king-sized bed with room to spare, and windows that offer views that'll make you want to sit back with a cup of joe and just take it all in. Oh, and let's not forget about that monster of a barn! It's like the ultimate man cave/she shed/playhouse for the kids/party spot all rolled into one. Plus, it comes with some extra outbuildings, so you'll have enough space to store all your toys, tools, or whatever else you can think of. You're looking at over 6 acres of pure fun. You can roam around outside, build some forts, throw a frisbee, or just kick back and enjoy the fresh air. If you're feeling adventurous, you can strap on your hiking boots or fire up the ATV/snowmobile and hit the trails, which are just a 2-minute stroll from your doorstep.